Overview

Dataset info

Number of variables67
Number of observations13604
Missing cells101152 (11.1%)
Duplicate rows0 (0.0%)
Total size in memory7.0 MiB
Average record size in memory536.0 B

Variables types

Numeric34
Categorical2
Boolean0
Date0
URL0
Text (Unique)1
Rejected30
Unsupported0

Warnings

avg_cash_1m is highly skewed (γ1 = 103.689676) Skewed
avg_cash_1m has 1794 (13.2%) missing values Missing
avg_cash_3m is highly correlated with avg_cash_1m (ρ = 0.999099545) Rejected
avg_cash_6m is highly correlated with avg_cash_3m (ρ = 0.9936676512) Rejected
avg_loan_1m has 9723 (71.5%) missing values Missing
avg_loan_3m is highly correlated with avg_loan_1m (ρ = 0.982995212) Rejected
avg_loan_6m is highly correlated with avg_loan_3m (ρ = 0.9830235048) Rejected
avg_portfolio_value_1m is highly skewed (γ1 = 57.17590837) Skewed
avg_portfolio_value_3m is highly correlated with avg_portfolio_value_1m (ρ = 0.994578141) Rejected
avg_portfolio_value_6m is highly correlated with avg_portfolio_value_3m (ρ = 0.9904928022) Rejected
avg_profit_per_6m has 6566 (48.3%) missing values Missing
avg_stock_count_1m is highly skewed (γ1 = 35.66018242) Skewed
avg_stock_count_3m is highly correlated with avg_stock_count_1m (ρ = 0.9902316431) Rejected
avg_stock_count_6m is highly correlated with avg_stock_count_3m (ρ = 0.9945684363) Rejected
buy_order has 11966 (88.0%) zeros Zeros
buy_order_1m has 7919 (58.2%) zeros Zeros
buy_order_3m has 5945 (43.7%) zeros Zeros
buy_order_6m is highly correlated with buy_order_3m (ρ = 0.9541051671) Rejected
buy_orders_1m_3m_per has 1974 (14.5%) zeros Zeros
buy_orders_1m_6m_per has 3104 (22.8%) zeros Zeros
cash_vs_1m has 6937 (51.0%) zeros Zeros
cash_vs_1m has 2142 (15.7%) missing values Missing
cash_vs_3m is highly correlated with cash_vs_1m (ρ = 0.9177938753) Rejected
cash_vs_6m is highly correlated with cash_vs_3m (ρ = 0.9191843439) Rejected
CashBalance is highly correlated with cash_vs_6m (ρ = 0.9575212639) Rejected
loan_vs_1m has 406 (3.0%) zeros Zeros
loan_vs_1m has 10235 (75.2%) missing values Missing
loan_vs_3m has 10235 (75.2%) missing values Missing
loan_vs_6m is highly correlated with loan_vs_3m (ρ = 0.9634403754) Rejected
LoanBalance is highly correlated with avg_loan_3m (ρ = 0.9520490662) Rejected
num_oder has 11385 (83.7%) zeros Zeros
port_value_vs_1m is highly skewed (γ1 = 56.33449157) Skewed
port_value_vs_1m has 333 (2.4%) zeros Zeros
port_value_vs_3m has 257 (1.9%) zeros Zeros
port_value_vs_6m is highly correlated with port_value_vs_3m (ρ = 0.9076132457) Rejected
portfolio_value is highly correlated with avg_portfolio_value_6m (ρ = 0.9673778626) Rejected
profit is highly skewed (γ1 = 25.84513152) Skewed
profit has 12447 (91.5%) zeros Zeros
profit_1m has 8893 (65.4%) zeros Zeros
profit_3m is highly skewed (γ1 = 115.58013) Skewed
profit_3m has 7316 (53.8%) zeros Zeros
profit_6m is highly correlated with profit_3m (ρ = 0.9943629294) Rejected
profit_per has 12437 (91.4%) missing values Missing
region has a high cardinality: 71 distinct values Warning
sell_order has 12437 (91.4%) zeros Zeros
sell_order_1m has 8865 (65.2%) zeros Zeros
sell_order_3m is highly correlated with sell_order_1m (ρ = 0.9065289845) Rejected
sell_order_6m is highly correlated with sell_order_3m (ρ = 0.9577278331) Rejected
sell_order_gain has 12944 (95.1%) zeros Zeros
sell_order_loss has 12942 (95.1%) zeros Zeros
sell_orders_1m_3m_per has 1568 (11.5%) zeros Zeros
sell_orders_1m_6m_per has 2299 (16.9%) zeros Zeros
stock_count is highly correlated with avg_stock_count_6m (ρ = 0.967179082) Rejected
stock_count_vs_1m has 10985 (80.7%) zeros Zeros
stock_count_vs_3m has 9952 (73.2%) zeros Zeros
stock_count_vs_6m is highly correlated with stock_count_vs_3m (ρ = 0.9005250291) Rejected
total_buy_order_1m_3m_per is highly correlated with buy_orders_1m_3m_per (ρ = 0.9809048155) Rejected
total_buy_order_1m_6m_per is highly correlated with buy_orders_1m_6m_per (ρ = 0.9834419742) Rejected
total_buy_value is highly skewed (γ1 = 33.59928488) Skewed
total_buy_value has 11966 (88.0%) zeros Zeros
total_buy_value_1m is highly skewed (γ1 = 111.4168123) Skewed
total_buy_value_1m has 7920 (58.2%) zeros Zeros
total_buy_value_3m is highly correlated with total_buy_value_1m (ρ = 0.9484353291) Rejected
total_buy_value_6m is highly skewed (γ1 = 99.82045008) Skewed
total_buy_value_6m has 4822 (35.4%) zeros Zeros
total_sell_order_1m_3m_per is highly correlated with sell_orders_1m_3m_per (ρ = 0.9806879469) Rejected
total_sell_order_1m_6m_per is highly correlated with sell_orders_1m_6m_per (ρ = 0.9863198197) Rejected
total_sell_value is highly skewed (γ1 = 32.59792884) Skewed
total_sell_value has 12437 (91.4%) zeros Zeros
total_sell_value_1m is highly skewed (γ1 = 76.04338338) Skewed
total_sell_value_1m has 8867 (65.2%) zeros Zeros
total_sell_value_3m is highly correlated with profit_6m (ρ = 0.9617840254) Rejected
total_sell_value_6m is highly correlated with total_sell_value_3m (ρ = 0.988218788) Rejected
trading_date has constant value "2019-09-30" Rejected
trading_month has constant value "9" Rejected

Variables

Age
Numeric

Distinct count79
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean39.34776536
Minimum0
Maximum94
Zeros (%)0.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile24
Q131
Median38
Q345
95-th percentile62
Maximum94
Range94
Interquartile range14

Descriptive statistics

Standard deviation11.78569364
Coef of variation0.299526378
Kurtosis1.096228827
Mean39.34776536
MAD9.008705951
Skewness0.4923783728
Sum535287
Variance138.9025746
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 1.5 18.5 20.5 23.5 ... 66.5 70.5 73.5 80.5 94. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
36 639 4.7%
 
35 632 4.6%
 
38 571 4.2%
 
37 567 4.2%
 
34 545 4.0%
 
30 515 3.8%
 
32 502 3.7%
 
39 497 3.7%
 
31 493 3.6%
 
29 468 3.4%
 
Other values (69) 8175 60.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 116 0.9%
 
3 1 < 0.1%
 
4 4 < 0.1%
 
6 1 < 0.1%
 
9 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
94 1 < 0.1%
 
89 1 < 0.1%
 
88 1 < 0.1%
 
87 1 < 0.1%
 
86 1 < 0.1%
 

avg_cash_1m
Numeric

Distinct count11592
Unique (%)85.2%
Missing (%)13.2%
Missing (n)1794
Infinite (%)0.0%
Infinite (n)0
Mean91789808.97
Minimum1
Maximum5.868472227e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2453.75
Q198256
Median943260.725
Q38656386.975
95-th percentile102519827.9
Maximum5.868472227e+11
Range5.868472227e+11
Interquartile range8558130.975

Descriptive statistics

Standard deviation5495863568
Coef of variation59.87444173
Kurtosis11016.55324
Mean91789808.97
MAD159437380.5
Skewness103.689676
Sum1.084037644e+12
Variance3.020451636e+19
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
220064 16 0.1%
 
342414 10 0.1%
 
1 7 0.1%
 
17 5 < 0.1%
 
219 5 < 0.1%
 
5 5 < 0.1%
 
179 5 < 0.1%
 
2300 4 < 0.1%
 
71 4 < 0.1%
 
1096 4 < 0.1%
 
Other values (11581) 11745 86.3%
 
(Missing) 1794 13.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 7 0.1%
 
2 2 < 0.1%
 
3 2 < 0.1%
 
4 2 < 0.1%
 
5 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5.868472227e+11 1 < 0.1%
 
1.066013554e+11 1 < 0.1%
 
1.661310946e+10 1 < 0.1%
 
1.402131235e+10 1 < 0.1%
 
1.172530387e+10 1 < 0.1%
 

avg_cash_3m
Highly correlated

This variable is highly correlated with avg_cash_1m and should be ignored for analysis

Correlation0.999099545

avg_cash_6m
Highly correlated

This variable is highly correlated with avg_cash_3m and should be ignored for analysis

Correlation0.9936676512

avg_loan_1m
Numeric

Distinct count3880
Unique (%)28.5%
Missing (%)71.5%
Missing (n)9723
Infinite (%)0.0%
Infinite (n)0
Mean1079097733
Minimum1
Maximum1.761755415e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1029127
Q129696319
Median113664492.8
Q3384190409.4
95-th percentile3110180832
Maximum1.761755415e+11
Range1.761755415e+11
Interquartile range354494090.4

Descriptive statistics

Standard deviation6563522764
Coef of variation6.082417344
Kurtosis339.9789419
Mean1079097733
MAD1590451153
Skewness16.23951948
Sum4.1879783e+12
Variance4.307983107e+19
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2 3 < 0.1%
 
587101517.6 1 < 0.1%
 
8300358 1 < 0.1%
 
128178611.4 1 < 0.1%
 
215276311 1 < 0.1%
 
8473931 1 < 0.1%
 
857295 1 < 0.1%
 
3184863297 1 < 0.1%
 
644665.8947 1 < 0.1%
 
51720091.75 1 < 0.1%
 
Other values (3869) 3869 28.4%
 
(Missing) 9723 71.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 < 0.1%
 
2 3 < 0.1%
 
5 1 < 0.1%
 
9 1 < 0.1%
 
13 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.761755415e+11 1 < 0.1%
 
1.62746467e+11 1 < 0.1%
 
1.501863354e+11 1 < 0.1%
 
1.017458212e+11 1 < 0.1%
 
9.688517257e+10 1 < 0.1%
 

avg_loan_3m
Highly correlated

This variable is highly correlated with avg_loan_1m and should be ignored for analysis

Correlation0.982995212

avg_loan_6m
Highly correlated

This variable is highly correlated with avg_loan_3m and should be ignored for analysis

Correlation0.9830235048

avg_portfolio_value_1m
Numeric

Distinct count12413
Unique (%)91.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3511439829
Minimum0
Maximum6.726841428e+12
Zeros (%)0.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile52717.25
Q12912511.625
Median46092690
Q3255812375
95-th percentile2360454725
Maximum6.726841428e+12
Range6.726841428e+12
Interquartile range252899863.4

Descriptive statistics

Standard deviation8.041718837e+10
Coef of variation22.90148551
Kurtosis4125.929071
Mean3511439829
MAD6319753027
Skewness57.17590837
Sum4.776962744e+13
Variance6.466924185e+21
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e+02 2.06387500e+04 2.06700000e+04 2.08662500e+04 ... 4.81522715e+10 9.49506765e+10 1.86592868e+11 8.11948812e+11 6.72684143e+12], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 106 0.8%
 
271375 67 0.5%
 
167000 49 0.4%
 
62625 44 0.3%
 
41750 40 0.3%
 
61965 34 0.2%
 
146125 33 0.2%
 
229625 32 0.2%
 
2254965 31 0.2%
 
343477250 25 0.2%
 
Other values (12403) 13143 96.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 106 0.8%
 
1000 1 < 0.1%
 
1320 1 < 0.1%
 
1400 1 < 0.1%
 
1500 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6.726841428e+12 1 < 0.1%
 
3.895901932e+12 1 < 0.1%
 
2.372319836e+12 1 < 0.1%
 
1.9923722e+12 1 < 0.1%
 
1.734016099e+12 1 < 0.1%
 

avg_portfolio_value_3m
Highly correlated

This variable is highly correlated with avg_portfolio_value_1m and should be ignored for analysis

Correlation0.994578141

avg_portfolio_value_6m
Highly correlated

This variable is highly correlated with avg_portfolio_value_3m and should be ignored for analysis

Correlation0.9904928022

avg_profit_per_6m
Numeric

Distinct count6925
Unique (%)50.9%
Missing (%)48.3%
Missing (n)6566
Infinite (%)0.0%
Infinite (n)0
Mean0.007628454389
Minimum-1
Maximum3.711188321
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum-1
5-th percentile-0.1130861688
Q1-0.02931301111
Median-0.004450231505
Q30.02467667158
95-th percentile0.1627218557
Maximum3.711188321
Range4.711188321
Interquartile range0.05398968269

Descriptive statistics

Standard deviation0.1288179404
Coef of variation16.88650595
Kurtosis150.3202316
Mean0.007628454389
MAD0.06029826319
Skewness6.896232708
Sum53.68906199
Variance0.01659406178
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 36 0.3%
 
-1 5 < 0.1%
 
-0.06015037594 4 < 0.1%
 
0.02510460251 4 < 0.1%
 
0.1 3 < 0.1%
 
0.07692307692 3 < 0.1%
 
0.1052631579 3 < 0.1%
 
0.02941176471 3 < 0.1%
 
-0.03759398496 3 < 0.1%
 
-0.1578947368 3 < 0.1%
 
Other values (6914) 6971 51.2%
 
(Missing) 6566 48.3%
 

Minimum 5 values

ValueCountFrequency (%) 
-1 5 < 0.1%
 
-0.9249146758 1 < 0.1%
 
-0.8531955146 1 < 0.1%
 
-0.7726784756 1 < 0.1%
 
-0.6626180837 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3.711188321 1 < 0.1%
 
2.743654822 1 < 0.1%
 
1.676056338 1 < 0.1%
 
1.610399146 1 < 0.1%
 
1.444444444 1 < 0.1%
 

avg_stock_count_1m
Numeric

Distinct count650
Unique (%)4.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.156561785
Minimum1
Maximum393
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34
95-th percentile9
Maximum393
Range392
Interquartile range3

Descriptive statistics

Standard deviation5.183603105
Coef of variation1.642167478
Kurtosis2424.765045
Mean3.156561785
MAD2.223472217
Skewness35.66018242
Sum42941.86652
Variance26.86974115
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 1.025 1.05409357 1.09545455 1.10263158 ... 16.025 22.15 35.675 120.475 393. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 5012 36.8%
 
2 1732 12.7%
 
3 917 6.7%
 
4 576 4.2%
 
5 338 2.5%
 
6 214 1.6%
 
7 135 1.0%
 
8 104 0.8%
 
9 63 0.5%
 
10 60 0.4%
 
Other values (640) 4453 32.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 5012 36.8%
 
1.05 52 0.4%
 
1.052631579 8 0.1%
 
1.055555556 1 < 0.1%
 
1.058823529 4 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
393 1 < 0.1%
 
121.2 1 < 0.1%
 
119.75 1 < 0.1%
 
111.95 1 < 0.1%
 
109.9 1 < 0.1%
 

avg_stock_count_3m
Highly correlated

This variable is highly correlated with avg_stock_count_1m and should be ignored for analysis

Correlation0.9902316431

avg_stock_count_6m
Highly correlated

This variable is highly correlated with avg_stock_count_3m and should be ignored for analysis

Correlation0.9945684363

buy_order
Numeric

Distinct count10
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.1789914731
Minimum0
Maximum9
Zeros (%)88.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.5852430512
Coef of variation3.269670008
Kurtosis34.92799677
Mean0.1789914731
MAD0.3148797364
Skewness4.92497328
Sum2435
Variance0.342509429
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 6.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 11966 88.0%
 
1 1146 8.4%
 
2 317 2.3%
 
3 99 0.7%
 
4 47 0.3%
 
5 15 0.1%
 
6 9 0.1%
 
9 2 < 0.1%
 
8 2 < 0.1%
 
7 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 11966 88.0%
 
1 1146 8.4%
 
2 317 2.3%
 
3 99 0.7%
 
4 47 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
9 2 < 0.1%
 
8 2 < 0.1%
 
7 1 < 0.1%
 
6 9 0.1%
 
5 15 0.1%
 

buy_order_1m
Numeric

Distinct count82
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.877389003
Minimum0
Maximum258
Zeros (%)58.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q33
95-th percentile14
Maximum258
Range258
Interquartile range3

Descriptive statistics

Standard deviation7.309659159
Coef of variation2.540379195
Kurtosis158.3257298
Mean2.877389003
MAD3.8247429
Skewness8.328488898
Sum39144
Variance53.43111702
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 ... 37.5 49.5 68.5 129. 258. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 7919 58.2%
 
1 1354 10.0%
 
2 784 5.8%
 
3 580 4.3%
 
4 490 3.6%
 
5 361 2.7%
 
6 268 2.0%
 
7 257 1.9%
 
8 207 1.5%
 
9 170 1.2%
 
Other values (72) 1214 8.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 7919 58.2%
 
1 1354 10.0%
 
2 784 5.8%
 
3 580 4.3%
 
4 490 3.6%
 

Maximum 5 values

ValueCountFrequency (%) 
258 1 < 0.1%
 
130 1 < 0.1%
 
128 1 < 0.1%
 
127 1 < 0.1%
 
109 1 < 0.1%
 

buy_order_3m
Numeric

Distinct count180
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.183990003
Minimum0
Maximum793
Zeros (%)43.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q39
95-th percentile42
Maximum793
Range793
Interquartile range9

Descriptive statistics

Standard deviation22.76311838
Coef of variation2.478565239
Kurtosis187.4377834
Mean9.183990003
MAD11.61070418
Skewness9.475589842
Sum124939
Variance518.1595584
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 4.500e+00 ... 8.850e+01 1.365e+02 1.760e+02 2.305e+02 7.930e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5945 43.7%
 
1 1435 10.5%
 
2 645 4.7%
 
3 428 3.1%
 
4 397 2.9%
 
5 334 2.5%
 
6 300 2.2%
 
7 285 2.1%
 
8 237 1.7%
 
9 212 1.6%
 
Other values (170) 3386 24.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5945 43.7%
 
1 1435 10.5%
 
2 645 4.7%
 
3 428 3.1%
 
4 397 2.9%
 

Maximum 5 values

ValueCountFrequency (%) 
793 1 < 0.1%
 
534 1 < 0.1%
 
474 1 < 0.1%
 
425 1 < 0.1%
 
408 1 < 0.1%
 

buy_order_6m
Highly correlated

This variable is highly correlated with buy_order_3m and should be ignored for analysis

Correlation0.9541051671

buy_orders_1m_3m_per
Numeric

Distinct count711
Unique (%)5.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.6373202265
Minimum0
Maximum1
Zeros (%)14.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10.2307692308
Median1
Q31
95-th percentile1
Maximum1
Range1
Interquartile range0.7692307692

Descriptive statistics

Standard deviation0.4105736767
Coef of variation0.644218808
Kurtosis-1.556919134
Mean0.6373202265
MAD0.3867238175
Skewness-0.4316511474
Sum8670.104362
Variance0.168570744
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0. 0.00961538 0.03077652 0.04880952 0.08248299 ... 0.79473684 0.80384615 0.93095238 0.99193548 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 7124 52.4%
 
0 1974 14.5%
 
0.5 330 2.4%
 
0.3333333333 274 2.0%
 
0.25 205 1.5%
 
0.2 171 1.3%
 
0.6666666667 120 0.9%
 
0.1666666667 116 0.9%
 
0.2857142857 103 0.8%
 
0.4 96 0.7%
 
Other values (701) 3091 22.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1974 14.5%
 
0.01923076923 1 < 0.1%
 
0.02040816327 1 < 0.1%
 
0.02222222222 1 < 0.1%
 
0.0243902439 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1 7124 52.4%
 
0.9838709677 1 < 0.1%
 
0.9705882353 1 < 0.1%
 
0.9666666667 1 < 0.1%
 
0.9545454545 1 < 0.1%
 

buy_orders_1m_6m_per
Numeric

Distinct count967
Unique (%)7.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.5155653086
Minimum0
Maximum1
Zeros (%)22.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10.05263157895
Median0.3888888889
Q31
95-th percentile1
Maximum1
Range1
Interquartile range0.9473684211

Descriptive statistics

Standard deviation0.4413275791
Coef of variation0.856007128
Kurtosis-1.82370802
Mean0.5155653086
MAD0.4222348346
Skewness0.05300237862
Sum7013.750458
Variance0.1947700321
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0. 0.004 0.01299578 0.03200205 0.05245958 ... 0.79285714 0.80384615 0.93095238 0.99193548 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 5756 42.3%
 
0 3104 22.8%
 
0.5 256 1.9%
 
0.3333333333 195 1.4%
 
0.25 161 1.2%
 
0.2 127 0.9%
 
0.1666666667 114 0.8%
 
0.125 104 0.8%
 
0.1428571429 100 0.7%
 
0.1111111111 98 0.7%
 
Other values (957) 3589 26.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 3104 22.8%
 
0.008 1 < 0.1%
 
0.01265822785 1 < 0.1%
 
0.01333333333 1 < 0.1%
 
0.01351351351 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1 5756 42.3%
 
0.9838709677 1 < 0.1%
 
0.9705882353 1 < 0.1%
 
0.9666666667 1 < 0.1%
 
0.9545454545 1 < 0.1%
 

cash_vs_1m
Numeric

Distinct count4405
Unique (%)32.4%
Missing (%)15.7%
Missing (n)2142
Infinite (%)0.0%
Infinite (n)0
Mean726967.6534
Minimum-7.584724702e+10
Maximum5.157112255e+10
Zeros (%)51.0%
Mini histogram

Quantile statistics

Minimum-7.584724702e+10
5-th percentile-25941612.48
Q10
Median0
Q30
95-th percentile12457042.61
Maximum5.157112255e+10
Range1.274183696e+11
Interquartile range0

Descriptive statistics

Standard deviation1012981537
Coef of variation1393.434127
Kurtosis3541.586039
Mean726967.6534
MAD37767879.09
Skewness-18.62859592
Sum8332503244
Variance1.026131595e+18
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 6937 51.0%
 
3230 8 0.1%
 
19380 6 < 0.1%
 
193800 6 < 0.1%
 
161500 6 < 0.1%
 
9500 5 < 0.1%
 
475 5 < 0.1%
 
16150 5 < 0.1%
 
5776 4 < 0.1%
 
47500 4 < 0.1%
 
Other values (4394) 4476 32.9%
 
(Missing) 2142 15.7%
 

Minimum 5 values

ValueCountFrequency (%) 
-7.584724702e+10 1 < 0.1%
 
-1.415609146e+10 1 < 0.1%
 
-1.355085659e+10 1 < 0.1%
 
-5878022982 1 < 0.1%
 
-4415000000 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5.157112255e+10 1 < 0.1%
 
3.247732373e+10 1 < 0.1%
 
2.927193892e+10 1 < 0.1%
 
2.84647159e+10 1 < 0.1%
 
8340618029 1 < 0.1%
 

cash_vs_3m
Highly correlated

This variable is highly correlated with cash_vs_1m and should be ignored for analysis

Correlation0.9177938753

cash_vs_6m
Highly correlated

This variable is highly correlated with cash_vs_3m and should be ignored for analysis

Correlation0.9191843439

CashBalance
Highly correlated

This variable is highly correlated with cash_vs_6m and should be ignored for analysis

Correlation0.9575212639

Gender
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)59
M
7553
F
5985
O
 
7
(Missing)
 
59
ValueCountFrequency (%) 
M 7553 55.5%
 
F 5985 44.0%
 
O 7 0.1%
 
(Missing) 59 0.4%
 
Max length4
Mean length1.013010879
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

loan_vs_1m
Numeric

Distinct count2956
Unique (%)21.7%
Missing (%)75.2%
Missing (n)10235
Infinite (%)0.0%
Infinite (n)0
Mean70477019.99
Minimum-3.389330217e+10
Maximum2.273403394e+10
Zeros (%)3.0%
Mini histogram

Quantile statistics

Minimum-3.389330217e+10
5-th percentile-171073408.6
Q1-8086008.75
Median0
Q339859560
95-th percentile463757292
Maximum2.273403394e+10
Range5.662733611e+10
Interquartile range47945568.75

Descriptive statistics

Standard deviation1138549436
Coef of variation16.1549032
Kurtosis343.0113857
Mean70477019.99
MAD241497658.9
Skewness-4.31810607
Sum2.374370803e+11
Variance1.296294818e+18
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 406 3.0%
 
-2375000 2 < 0.1%
 
-13326.4 2 < 0.1%
 
1479363.636 2 < 0.1%
 
-4275000 2 < 0.1%
 
-20548500 2 < 0.1%
 
-760000 2 < 0.1%
 
-6750000000 2 < 0.1%
 
-50000 2 < 0.1%
 
-361667.7 2 < 0.1%
 
Other values (2945) 2945 21.6%
 
(Missing) 10235 75.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-3.389330217e+10 1 < 0.1%
 
-1.866150068e+10 1 < 0.1%
 
-1.319341883e+10 1 < 0.1%
 
-6750000000 2 < 0.1%
 
-6009409406 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.273403394e+10 1 < 0.1%
 
1.478023073e+10 1 < 0.1%
 
1.44956863e+10 1 < 0.1%
 
1.382210686e+10 1 < 0.1%
 
1.347580698e+10 1 < 0.1%
 

loan_vs_3m
Numeric

Distinct count3260
Unique (%)24.0%
Missing (%)75.2%
Missing (n)10235
Infinite (%)0.0%
Infinite (n)0
Mean111324959.6
Minimum-5.988427975e+10
Maximum3.274134179e+10
Zeros (%)0.8%
Mini histogram

Quantile statistics

Minimum-5.988427975e+10
5-th percentile-241272083.1
Q1-16208625
Median2250306.262
Q370211272.04
95-th percentile742796138.9
Maximum3.274134179e+10
Range9.262562155e+10
Interquartile range86419897.04

Descriptive statistics

Standard deviation2190818630
Coef of variation19.67949181
Kurtosis412.1779
Mean111324959.6
MAD394694935
Skewness-11.44564399
Sum3.750537888e+11
Variance4.79968627e+18
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 111 0.8%
 
-703481.4545 1 < 0.1%
 
3195643.636 1 < 0.1%
 
-71296971.29 1 < 0.1%
 
781236417.2 1 < 0.1%
 
-44647550.16 1 < 0.1%
 
-88894722.33 1 < 0.1%
 
313199066.5 1 < 0.1%
 
11331673.52 1 < 0.1%
 
2728711.429 1 < 0.1%
 
Other values (3249) 3249 23.9%
 
(Missing) 10235 75.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-5.988427975e+10 1 < 0.1%
 
-5.798337541e+10 1 < 0.1%
 
-4.68623551e+10 1 < 0.1%
 
-1.311579666e+10 1 < 0.1%
 
-1.310427327e+10 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3.274134179e+10 1 < 0.1%
 
3.05322242e+10 1 < 0.1%
 
2.379214094e+10 1 < 0.1%
 
1.792668322e+10 1 < 0.1%
 
1.777537086e+10 1 < 0.1%
 

loan_vs_6m
Highly correlated

This variable is highly correlated with loan_vs_3m and should be ignored for analysis

Correlation0.9634403754

LoanBalance
Highly correlated

This variable is highly correlated with avg_loan_3m and should be ignored for analysis

Correlation0.9520490662

main_account
Categorical, Unique

First 5 values
0001898ab3584ff6a99ec11ffcb1f09c
00029e5f2da54460a1d7dd1a491d991f
00057207ba05405a911387bbcb3861bc
000a64c8a9d5465eba885a561e1b0ca9
001d09340ebb4b95af55684d8635a819
Last 5 values
ffe8f9741d61422eac913ca1fce1c95f
ffef4d87ab1f4afc96255d56b1eec790
fff283aac89f4f82ab8b931dd9a9e41e
fff942970c8d4976993aa8e949f2c228
fff95069a1554792bfe041e2f7b184bc

First 5 values

ValueCountFrequency (%) 
0001898ab3584ff6a99ec11ffcb1f09c 1 < 0.1%
 
00029e5f2da54460a1d7dd1a491d991f 1 < 0.1%
 
00057207ba05405a911387bbcb3861bc 1 < 0.1%
 
000a64c8a9d5465eba885a561e1b0ca9 1 < 0.1%
 
001d09340ebb4b95af55684d8635a819 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
fff95069a1554792bfe041e2f7b184bc 1 < 0.1%
 
fff942970c8d4976993aa8e949f2c228 1 < 0.1%
 
fff283aac89f4f82ab8b931dd9a9e41e 1 < 0.1%
 
ffef4d87ab1f4afc96255d56b1eec790 1 < 0.1%
 
ffe8f9741d61422eac913ca1fce1c95f 1 < 0.1%
 

num_oder
Numeric

Distinct count14
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.3024845634
Minimum0
Maximum27
Zeros (%)83.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum27
Range27
Interquartile range0

Descriptive statistics

Standard deviation0.9132913055
Coef of variation3.019298887
Kurtosis79.3953906
Mean0.3024845634
MAD0.5062903196
Skewness6.025545905
Sum4115
Variance0.8341010087
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=14)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 6.5 8.5 11.5 27. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 11385 83.7%
 
1 1287 9.5%
 
2 483 3.6%
 
3 223 1.6%
 
4 107 0.8%
 
5 53 0.4%
 
6 29 0.2%
 
7 13 0.1%
 
8 12 0.1%
 
10 4 < 0.1%
 
Other values (4) 8 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 11385 83.7%
 
1 1287 9.5%
 
2 483 3.6%
 
3 223 1.6%
 
4 107 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
27 1 < 0.1%
 
12 1 < 0.1%
 
11 3 < 0.1%
 
10 4 < 0.1%
 
9 3 < 0.1%
 

port_value_vs_1m
Numeric

Distinct count11790
Unique (%)86.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean144910865.6
Minimum-9.830860829e+10
Maximum3.706249945e+11
Zeros (%)2.4%
Mini histogram

Quantile statistics

Minimum-9.830860829e+10
5-th percentile-60083345
Q1-160367.5
Median16442.5
Q36195187.5
95-th percentile182180999.7
Maximum3.706249945e+11
Range4.689336028e+11
Interquartile range6355555

Descriptive statistics

Standard deviation4228565006
Coef of variation29.18045509
Kurtosis4542.084143
Mean144910865.6
MAD337269872.7
Skewness56.33449157
Sum1.971367416e+12
Variance1.788076201e+19
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-9.83086083e+10 -1.36701909e+10 -3.03975542e+09 -1.01124500e+09 -5.84066938e+08 ... 2.21790195e+09 5.37080886e+09 1.82610628e+10 1.04580500e+11 3.70624994e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 333 2.4%
 
15275 67 0.5%
 
9400 49 0.4%
 
3525 45 0.3%
 
2350 42 0.3%
 
1335 34 0.2%
 
8225 33 0.2%
 
12925 32 0.2%
 
-12765 31 0.2%
 
19333450 25 0.2%
 
Other values (11780) 12913 94.9%
 

Minimum 5 values

ValueCountFrequency (%) 
-9.830860829e+10 1 < 0.1%
 
-3.097203787e+10 1 < 0.1%
 
-2.848382964e+10 1 < 0.1%
 
-1.856616175e+10 1 < 0.1%
 
-1.40365349e+10 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3.706249945e+11 1 < 0.1%
 
1.335317752e+11 1 < 0.1%
 
1.1178384e+11 1 < 0.1%
 
9.737715978e+10 1 < 0.1%
 
9.70063935e+10 1 < 0.1%
 

port_value_vs_3m
Numeric

Distinct count12348
Unique (%)90.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean160652168.3
Minimum-8.38775852e+11
Maximum8.72527666e+11
Zeros (%)1.9%
Mini histogram

Quantile statistics

Minimum-8.38775852e+11
5-th percentile-126889800.1
Q1-1357746.154
Median4624.230769
Q310598760.38
95-th percentile317715156.2
Maximum8.72527666e+11
Range1.711303518e+12
Interquartile range11956506.54

Descriptive statistics

Standard deviation1.165843025e+10
Coef of variation72.56939248
Kurtosis4322.562871
Mean160652168.3
MAD621804649.2
Skewness5.499470041
Sum2.185512097e+12
Variance1.359189959e+20
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-8.38775852e+11 -8.42141999e+10 -1.43699935e+10 -2.91842229e+09 -1.62137529e+09 ... 5.53204607e+09 1.40782227e+10 4.14074431e+10 2.34639939e+11 8.72527666e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 257 1.9%
 
29210 67 0.5%
 
17975.38462 45 0.3%
 
6740.769231 43 0.3%
 
4493.846154 38 0.3%
 
-950.7692308 34 0.2%
 
15728.46154 32 0.2%
 
24716.15385 32 0.2%
 
-3221.538462 31 0.2%
 
36970872.31 25 0.2%
 
Other values (12338) 13000 95.6%
 

Minimum 5 values

ValueCountFrequency (%) 
-8.38775852e+11 1 < 0.1%
 
-1.794365538e+11 1 < 0.1%
 
-8.827642019e+10 1 < 0.1%
 
-8.01519796e+10 1 < 0.1%
 
-7.716681874e+10 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8.72527666e+11 1 < 0.1%
 
2.5534947e+11 1 < 0.1%
 
2.139304086e+11 1 < 0.1%
 
1.8775431e+11 1 < 0.1%
 
1.874648158e+11 1 < 0.1%
 

port_value_vs_6m
Highly correlated

This variable is highly correlated with port_value_vs_3m and should be ignored for analysis

Correlation0.9076132457

portfolio_value
Highly correlated

This variable is highly correlated with avg_portfolio_value_6m and should be ignored for analysis

Correlation0.9673778626

profit
Numeric

Distinct count1007
Unique (%)7.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean117809.4624
Minimum-349347980
Maximum615615000
Zeros (%)91.5%
Mini histogram

Quantile statistics

Minimum-349347980
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum615615000
Range964962980
Interquartile range0

Descriptive statistics

Standard deviation9863835.39
Coef of variation83.72702152
Kurtosis1946.161602
Mean117809.4624
MAD763559.9918
Skewness25.84513152
Sum1602679926
Variance9.729524861e+13
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-3.4934798e+08 -1.2010400e+08 -3.9120765e+07 -1.4703250e+07 -6.7050000e+06 ... 9.2650900e+06 1.7068000e+07 5.7881750e+07 2.0793996e+08 6.1561500e+08], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 12447 91.5%
 
250000 7 0.1%
 
60000 5 < 0.1%
 
-80000 5 < 0.1%
 
-1200000 4 < 0.1%
 
-200000 4 < 0.1%
 
360000 4 < 0.1%
 
50000 4 < 0.1%
 
800000 4 < 0.1%
 
-30000 4 < 0.1%
 
Other values (997) 1116 8.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-349347980 1 < 0.1%
 
-318174550 1 < 0.1%
 
-127228000 1 < 0.1%
 
-112980000 1 < 0.1%
 
-102435000 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
615615000 1 < 0.1%
 
519606400 1 < 0.1%
 
216000000 1 < 0.1%
 
199879920 1 < 0.1%
 
194221500 1 < 0.1%
 

profit_1m
Numeric

Distinct count4275
Unique (%)31.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-4321903.938
Minimum-1.710295648e+10
Maximum1.658551664e+10
Zeros (%)65.4%
Mini histogram

Quantile statistics

Minimum-1.710295648e+10
5-th percentile-20455944.5
Q10
Median0
Q30
95-th percentile4620706.25
Maximum1.658551664e+10
Range3.368847312e+10
Interquartile range0

Descriptive statistics

Standard deviation228883856.7
Coef of variation-52.95903379
Kurtosis4366.427447
Mean-4321903.938
MAD16537083.04
Skewness-3.018362292
Sum-5.879518117e+10
Variance5.238781985e+16
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.71029565e+10 -2.14753600e+09 -9.67038700e+08 -3.45363500e+08 -1.85740115e+08 ... 6.26865400e+07 1.42768320e+08 2.86889650e+08 1.15791714e+09 1.65855166e+10], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8893 65.4%
 
50000 10 0.1%
 
-200000 8 0.1%
 
6000 7 0.1%
 
100000 7 0.1%
 
-900000 6 < 0.1%
 
-300000 6 < 0.1%
 
-3500000 6 < 0.1%
 
-170000 6 < 0.1%
 
-350000 6 < 0.1%
 
Other values (4265) 4649 34.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-1.710295648e+10 1 < 0.1%
 
-4795443160 1 < 0.1%
 
-4101002000 1 < 0.1%
 
-2265000000 1 < 0.1%
 
-2030072000 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.658551664e+10 1 < 0.1%
 
5395040000 1 < 0.1%
 
2401551060 1 < 0.1%
 
1712923410 1 < 0.1%
 
1589843720 1 < 0.1%
 

profit_3m
Numeric

Distinct count5926
Unique (%)43.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean36171208.98
Minimum-1.5608975e+10
Maximum5.394120453e+11
Zeros (%)53.8%
Mini histogram

Quantile statistics

Minimum-1.5608975e+10
5-th percentile-46098213
Q1-16825
Median0
Q30
95-th percentile20831631
Maximum5.394120453e+11
Range5.550210203e+11
Interquartile range16825

Descriptive statistics

Standard deviation4638865111
Coef of variation128.2474443
Kurtosis13439.42418
Mean36171208.98
MAD102259660.2
Skewness115.58013
Sum4.92073127e+11
Variance2.151906951e+19
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.56089750e+10 -4.70445215e+09 -1.41114450e+09 -6.96623830e+08 -3.96705865e+08 ... 3.01177850e+08 6.07549115e+08 3.55592540e+09 1.65007302e+10 5.39412045e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 7316 53.8%
 
-100000 8 0.1%
 
150000 8 0.1%
 
200000 6 < 0.1%
 
800000 6 < 0.1%
 
-200000 6 < 0.1%
 
-40000 6 < 0.1%
 
100000 5 < 0.1%
 
50000 5 < 0.1%
 
300000 5 < 0.1%
 
Other values (5916) 6233 45.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-1.5608975e+10 1 < 0.1%
 
-1.362708333e+10 1 < 0.1%
 
-1.12361121e+10 1 < 0.1%
 
-4950650000 1 < 0.1%
 
-4458254300 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5.394120453e+11 1 < 0.1%
 
1.772901048e+10 1 < 0.1%
 
1.527245e+10 1 < 0.1%
 
1.51568364e+10 1 < 0.1%
 
8133764640 1 < 0.1%
 

profit_6m
Highly correlated

This variable is highly correlated with profit_3m and should be ignored for analysis

Correlation0.9943629294

profit_per
Numeric

Distinct count1057
Unique (%)7.8%
Missing (%)91.4%
Missing (n)12437
Infinite (%)0.0%
Infinite (n)0
Mean-0.006972851696
Minimum-0.932
Maximum0.5087719298
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum-0.932
5-th percentile-0.1493567382
Q1-0.03215310904
Median0
Q30.0295031947
95-th percentile0.1012985049
Maximum0.5087719298
Range1.44077193
Interquartile range0.06165630375

Descriptive statistics

Standard deviation0.0884352132
Coef of variation-12.68278992
Kurtosis16.25935014
Mean-0.006972851696
MAD0.05380847175
Skewness-1.298429184
Sum-8.137317929
Variance0.007820786933
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 10 0.1%
 
0.02610759494 10 0.1%
 
-0.02071005917 10 0.1%
 
-0.0313253012 8 0.1%
 
0.03202846975 6 < 0.1%
 
0.0623556582 6 < 0.1%
 
-0.0293255132 6 < 0.1%
 
0.1052631579 4 < 0.1%
 
0.02206461781 4 < 0.1%
 
0.03401360544 3 < 0.1%
 
Other values (1046) 1100 8.1%
 
(Missing) 12437 91.4%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.932 1 < 0.1%
 
-0.5227068664 1 < 0.1%
 
-0.5188764514 1 < 0.1%
 
-0.4219979136 1 < 0.1%
 
-0.4193548387 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
0.5087719298 1 < 0.1%
 
0.4194101225 1 < 0.1%
 
0.3996586198 1 < 0.1%
 
0.3930348259 1 < 0.1%
 
0.3898641614 1 < 0.1%
 

region
Categorical

Distinct count71
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
HN
3940
DVSN
3385
HCM
1995
Other values (68)
4284
ValueCountFrequency (%) 
HN 3940 29.0%
 
DVSN 3385 24.9%
 
HCM 1995 14.7%
 
NgheAn 246 1.8%
 
DaNang 195 1.4%
 
ThanhHoa 193 1.4%
 
DongNai 187 1.4%
 
NamDinh 168 1.2%
 
BacNinh 158 1.2%
 
HaiPhong 148 1.1%
 
Other values (61) 2989 22.0%
 
Max length10
Mean length4.250882094
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sell_order
Numeric

Distinct count11
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.1234930903
Minimum0
Maximum18
Zeros (%)91.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum18
Range18
Interquartile range0

Descriptive statistics

Standard deviation0.5023309343
Coef of variation4.067684542
Kurtosis162.5919919
Mean0.1234930903
MAD0.2257988185
Skewness8.550222405
Sum1680
Variance0.2523363676
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=11)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 8.5 18. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 12437 91.4%
 
1 856 6.3%
 
2 202 1.5%
 
3 64 0.5%
 
4 28 0.2%
 
5 8 0.1%
 
7 3 < 0.1%
 
6 2 < 0.1%
 
8 2 < 0.1%
 
18 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 12437 91.4%
 
1 856 6.3%
 
2 202 1.5%
 
3 64 0.5%
 
4 28 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
18 1 < 0.1%
 
9 1 < 0.1%
 
8 2 < 0.1%
 
7 3 < 0.1%
 
6 2 < 0.1%
 

sell_order_1m
Numeric

Distinct count71
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.139223758
Minimum0
Maximum199
Zeros (%)65.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile11
Maximum199
Range199
Interquartile range2

Descriptive statistics

Standard deviation6.141631988
Coef of variation2.870962874
Kurtosis165.7239961
Mean2.139223758
MAD2.999617915
Skewness9.172206545
Sum29102
Variance37.71964348
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 26.5 33.5 50. 85. 199. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8865 65.2%
 
1 1167 8.6%
 
2 788 5.8%
 
3 531 3.9%
 
4 376 2.8%
 
5 293 2.2%
 
6 259 1.9%
 
7 192 1.4%
 
8 157 1.2%
 
9 141 1.0%
 
Other values (61) 835 6.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 8865 65.2%
 
1 1167 8.6%
 
2 788 5.8%
 
3 531 3.9%
 
4 376 2.8%
 

Maximum 5 values

ValueCountFrequency (%) 
199 1 < 0.1%
 
157 1 < 0.1%
 
125 1 < 0.1%
 
115 1 < 0.1%
 
103 1 < 0.1%
 

sell_order_3m
Highly correlated

This variable is highly correlated with sell_order_1m and should be ignored for analysis

Correlation0.9065289845

sell_order_6m
Highly correlated

This variable is highly correlated with sell_order_3m and should be ignored for analysis

Correlation0.9577278331

sell_order_gain
Numeric

Distinct count7
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.06093795942
Minimum0
Maximum7
Zeros (%)95.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.3065702678
Coef of variation5.030858773
Kurtosis77.7788638
Mean0.06093795942
MAD0.1159630913
Skewness7.267902874
Sum829
Variance0.09398532909
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 7. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 12944 95.1%
 
1 542 4.0%
 
2 86 0.6%
 
3 21 0.2%
 
5 5 < 0.1%
 
4 5 < 0.1%
 
7 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 12944 95.1%
 
1 542 4.0%
 
2 86 0.6%
 
3 21 0.2%
 
4 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7 1 < 0.1%
 
5 5 < 0.1%
 
4 5 < 0.1%
 
3 21 0.2%
 
2 86 0.6%
 

sell_order_loss
Numeric

Distinct count8
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.06057042046
Minimum0
Maximum11
Zeros (%)95.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum11
Range11
Interquartile range0

Descriptive statistics

Standard deviation0.3079588229
Coef of variation5.084310469
Kurtosis164.8590216
Mean0.06057042046
MAD0.1152458662
Skewness8.923036774
Sum824
Variance0.09483863659
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 11. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 12942 95.1%
 
1 546 4.0%
 
2 88 0.6%
 
3 20 0.1%
 
4 5 < 0.1%
 
6 1 < 0.1%
 
5 1 < 0.1%
 
11 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 12942 95.1%
 
1 546 4.0%
 
2 88 0.6%
 
3 20 0.1%
 
4 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 < 0.1%
 
6 1 < 0.1%
 
5 1 < 0.1%
 
4 5 < 0.1%
 
3 20 0.1%
 

sell_orders_1m_3m_per
Numeric

Distinct count566
Unique (%)4.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.701648483
Minimum0
Maximum1
Zeros (%)11.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10.3181818182
Median1
Q31
95-th percentile1
Maximum1
Range1
Interquartile range0.6818181818

Descriptive statistics

Standard deviation0.3928197584
Coef of variation0.559852644
Kurtosis-1.177668115
Mean0.701648483
MAD0.360876928
Skewness-0.7428339894
Sum9545.225963
Variance0.1543073626
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0. 0.00649351 0.0274024 0.04880952 0.08220721 ... 0.85449735 0.86038961 0.91106719 0.98913043 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 8142 59.9%
 
0 1568 11.5%
 
0.5 346 2.5%
 
0.3333333333 295 2.2%
 
0.25 179 1.3%
 
0.6666666667 148 1.1%
 
0.2 130 1.0%
 
0.1666666667 100 0.7%
 
0.4 89 0.7%
 
0.75 81 0.6%
 
Other values (556) 2526 18.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1568 11.5%
 
0.01298701299 1 < 0.1%
 
0.01724137931 1 < 0.1%
 
0.02702702703 1 < 0.1%
 
0.02777777778 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1 8142 59.9%
 
0.9782608696 1 < 0.1%
 
0.962962963 1 < 0.1%
 
0.9523809524 1 < 0.1%
 
0.9375 1 < 0.1%
 

sell_orders_1m_6m_per
Numeric

Distinct count785
Unique (%)5.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.6163211648
Minimum0
Maximum1
Zeros (%)16.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10.1363636364
Median1
Q31
95-th percentile1
Maximum1
Range1
Interquartile range0.8636363636

Descriptive statistics

Standard deviation0.434040184
Coef of variation0.7042435159
Kurtosis-1.702532803
Mean0.6163211648
MAD0.4155169174
Skewness-0.3702163563
Sum8384.433126
Variance0.1883908813
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0. 0.00362319 0.02150786 0.04706534 0.04808137 ... 0.79473684 0.80384615 0.91106719 0.98913043 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 7249 53.3%
 
0 2299 16.9%
 
0.5 223 1.6%
 
0.3333333333 189 1.4%
 
0.2 166 1.2%
 
0.25 147 1.1%
 
0.1666666667 107 0.8%
 
0.6666666667 106 0.8%
 
0.1428571429 91 0.7%
 
0.4 75 0.6%
 
Other values (775) 2952 21.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2299 16.9%
 
0.007246376812 1 < 0.1%
 
0.008064516129 1 < 0.1%
 
0.01063829787 1 < 0.1%
 
0.01515151515 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1 7249 53.3%
 
0.9782608696 1 < 0.1%
 
0.9701492537 1 < 0.1%
 
0.962962963 1 < 0.1%
 
0.9523809524 1 < 0.1%
 

stock_count
Highly correlated

This variable is highly correlated with avg_stock_count_6m and should be ignored for analysis

Correlation0.967179082

stock_count_vs_1m
Numeric

Distinct count21
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.04483975301
Minimum-28
Maximum12
Zeros (%)80.7%
Mini histogram

Quantile statistics

Minimum-28
5-th percentile-1
Q10
Median0
Q30
95-th percentile1
Maximum12
Range40
Interquartile range0

Descriptive statistics

Standard deviation0.7989300236
Coef of variation17.81744925
Kurtosis136.4729324
Mean0.04483975301
MAD0.3180316667
Skewness-1.760603746
Sum610
Variance0.6382891826
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=21)
Histogram
Histogram with variable size bins (bins=[-28. -9.5 -4.5 -3.5 -2.5 ... 2.5 3.5 4.5 6.5 12. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 10985 80.7%
 
1 965 7.1%
 
-1 881 6.5%
 
2 310 2.3%
 
-2 215 1.6%
 
3 109 0.8%
 
-3 52 0.4%
 
4 31 0.2%
 
-4 19 0.1%
 
5 12 0.1%
 
Other values (11) 25 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-28 1 < 0.1%
 
-12 1 < 0.1%
 
-7 2 < 0.1%
 
-6 1 < 0.1%
 
-5 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
12 1 < 0.1%
 
10 2 < 0.1%
 
9 3 < 0.1%
 
8 2 < 0.1%
 
7 3 < 0.1%
 

stock_count_vs_3m
Numeric

Distinct count29
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.08431343722
Minimum-26
Maximum18
Zeros (%)73.2%
Mini histogram

Quantile statistics

Minimum-26
5-th percentile-1
Q10
Median0
Q30
95-th percentile2
Maximum18
Range44
Interquartile range0

Descriptive statistics

Standard deviation1.131645426
Coef of variation13.42188698
Kurtosis53.11587262
Mean0.08431343722
MAD0.5097561547
Skewness1.242703551
Sum1147
Variance1.280621369
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=29)
Histogram
Histogram with variable size bins (bins=[-26. -7.5 -4.5 -3.5 -2.5 ... 3.5 4.5 6.5 10.5 18. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 9952 73.2%
 
1 1205 8.9%
 
-1 1137 8.4%
 
2 449 3.3%
 
-2 330 2.4%
 
3 184 1.4%
 
-3 100 0.7%
 
4 80 0.6%
 
-4 40 0.3%
 
5 33 0.2%
 
Other values (19) 94 0.7%
 

Minimum 5 values

ValueCountFrequency (%) 
-26 1 < 0.1%
 
-15 1 < 0.1%
 
-11 1 < 0.1%
 
-10 2 < 0.1%
 
-8 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
18 1 < 0.1%
 
16 1 < 0.1%
 
15 3 < 0.1%
 
14 2 < 0.1%
 
12 1 < 0.1%
 

stock_count_vs_6m
Highly correlated

This variable is highly correlated with stock_count_vs_3m and should be ignored for analysis

Correlation0.9005250291

total_buy_order_1m_3m_per
Highly correlated

This variable is highly correlated with buy_orders_1m_3m_per and should be ignored for analysis

Correlation0.9809048155

total_buy_order_1m_6m_per
Highly correlated

This variable is highly correlated with buy_orders_1m_6m_per and should be ignored for analysis

Correlation0.9834419742

total_buy_value
Numeric

Distinct count1372
Unique (%)10.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean26703523.72
Minimum0
Maximum1.7157975e+10
Zeros (%)88.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile48234000
Maximum1.7157975e+10
Range1.7157975e+10
Interquartile range0

Descriptive statistics

Standard deviation353506456.7
Coef of variation13.23819509
Kurtosis1363.955774
Mean26703523.72
MAD48974350.09
Skewness33.59928488
Sum3.632747368e+11
Variance1.249668149e+17
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 1.1325000e+04 2.5525000e+04 1.8340000e+06 7.2710000e+06 ... 3.3131600e+08 7.0250000e+08 1.1606080e+09 3.9513000e+09 1.7157975e+10], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 11966 88.0%
 
33100000 11 0.1%
 
18100000 10 0.1%
 
22650 8 0.1%
 
99300000 6 < 0.1%
 
165500000 5 < 0.1%
 
19700000 5 < 0.1%
 
1810000 5 < 0.1%
 
16550000 5 < 0.1%
 
138033000 4 < 0.1%
 
Other values (1362) 1579 11.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 11966 88.0%
 
22650 8 0.1%
 
28400 1 < 0.1%
 
47000 1 < 0.1%
 
62400 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.7157975e+10 1 < 0.1%
 
1.624e+10 1 < 0.1%
 
1.518003e+10 1 < 0.1%
 
1.46419113e+10 1 < 0.1%
 
1.10079e+10 1 < 0.1%
 

total_buy_value_1m
Numeric

Distinct count5410
Unique (%)39.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean433664573.2
Minimum0
Maximum1.517087434e+12
Zeros (%)58.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q358715000
95-th percentile1068707642
Maximum1.517087434e+12
Range1.517087434e+12
Interquartile range58715000

Descriptive statistics

Standard deviation1.320953789e+10
Coef of variation30.46026515
Kurtosis12778.54024
Mean433664573.2
MAD719720634.7
Skewness111.4168123
Sum5.899572854e+12
Variance1.744918912e+20
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e+02 2.45100000e+05 1.27727500e+06 4.99900000e+06 ... 6.72177500e+09 1.75780045e+10 3.25116998e+10 5.78454355e+10 1.51708743e+12], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 7920 58.2%
 
3590000 8 0.1%
 
1795000 7 0.1%
 
135529000 6 < 0.1%
 
8975000 6 < 0.1%
 
7180000 6 < 0.1%
 
89750 5 < 0.1%
 
22650 5 < 0.1%
 
110470500 4 < 0.1%
 
138033000 4 < 0.1%
 
Other values (5400) 5633 41.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 7920 58.2%
 
1000 1 < 0.1%
 
4200 3 < 0.1%
 
6000 1 < 0.1%
 
8400 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.517087434e+12 1 < 0.1%
 
1.22e+11 1 < 0.1%
 
1.012085485e+11 1 < 0.1%
 
6.4949831e+10 1 < 0.1%
 
5.074104e+10 1 < 0.1%
 

total_buy_value_3m
Highly correlated

This variable is highly correlated with total_buy_value_1m and should be ignored for analysis

Correlation0.9484353291

total_buy_value_6m
Numeric

Distinct count8335
Unique (%)61.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2441528103
Minimum0
Maximum6.754880554e+12
Zeros (%)35.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median19349650
Q3455675125
95-th percentile6268552400
Maximum6.754880554e+12
Range6.754880554e+12
Interquartile range455675125

Descriptive statistics

Standard deviation6.149979756e+10
Coef of variation25.18905987
Kurtosis10758.92576
Mean2441528103
MAD3967073178
Skewness99.82045008
Sum3.321454831e+13
Variance3.7822251e+21
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 2.10000000e+03 2.17500000e+04 2.35000000e+04 2.37000000e+04 ... 4.69836855e+10 8.59139626e+10 1.81239734e+11 5.66247875e+11 6.75488055e+12], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 4822 35.4%
 
233200 32 0.2%
 
44650 13 0.1%
 
23600 12 0.1%
 
111000 11 0.1%
 
22200 11 0.1%
 
44400 8 0.1%
 
445200 7 0.1%
 
310800 7 0.1%
 
88800 6 < 0.1%
 
Other values (8325) 8675 63.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4822 35.4%
 
4200 3 < 0.1%
 
6800 1 < 0.1%
 
7000 1 < 0.1%
 
7500 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6.754880554e+12 1 < 0.1%
 
1.936789406e+12 1 < 0.1%
 
6.93925e+11 1 < 0.1%
 
4.3857075e+11 1 < 0.1%
 
3.967535841e+11 1 < 0.1%
 

total_sell_order_1m_3m_per
Highly correlated

This variable is highly correlated with sell_orders_1m_3m_per and should be ignored for analysis

Correlation0.9806879469

total_sell_order_1m_6m_per
Highly correlated

This variable is highly correlated with sell_orders_1m_6m_per and should be ignored for analysis

Correlation0.9863198197

total_sell_value
Numeric

Distinct count1025
Unique (%)7.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean14129442.43
Minimum0
Maximum1.003275e+10
Zeros (%)91.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile23302000
Maximum1.003275e+10
Range1.003275e+10
Interquartile range0

Descriptive statistics

Standard deviation156766338.6
Coef of variation11.09501237
Kurtosis1577.836066
Mean14129442.43
MAD26325774.17
Skewness32.59792884
Sum1.922169348e+11
Variance2.457568491e+16
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000000e+00 1.6250000e+04 2.5920000e+06 1.1492500e+07 2.4294000e+07 ... 3.0236900e+08 6.9981125e+08 1.5701045e+09 2.7568400e+09 1.0032750e+10], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 12437 91.4%
 
16550000 6 < 0.1%
 
66200000 5 < 0.1%
 
18100000 5 < 0.1%
 
1150000 4 < 0.1%
 
40200000 4 < 0.1%
 
3620000 4 < 0.1%
 
33600000 4 < 0.1%
 
160800000 4 < 0.1%
 
2560000 4 < 0.1%
 
Other values (1015) 1127 8.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 12437 91.4%
 
32500 2 < 0.1%
 
62400 1 < 0.1%
 
68000 1 < 0.1%
 
69200 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.003275e+10 1 < 0.1%
 
5896074000 1 < 0.1%
 
5009760000 1 < 0.1%
 
4256250000 1 < 0.1%
 
3801000000 1 < 0.1%
 

total_sell_value_1m
Numeric

Distinct count4552
Unique (%)33.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean283727916.1
Minimum0
Maximum3.91607438e+11
Zeros (%)65.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q329303250
95-th percentile833674250
Maximum3.91607438e+11
Range3.91607438e+11
Interquartile range29303250

Descriptive statistics

Standard deviation3943894189
Coef of variation13.90026841
Kurtosis7223.185984
Mean283727916.1
MAD471326025.3
Skewness76.04338338
Sum3.859834571e+12
Variance1.555430137e+19
Memory size106.4 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e+02 1.32170000e+06 6.62450000e+06 2.23710000e+07 ... 6.91127410e+09 1.26510986e+10 3.15418694e+10 7.14086750e+10 3.91607438e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8867 65.2%
 
20700000 5 < 0.1%
 
19500000 5 < 0.1%
 
72000000 4 < 0.1%
 
1150000 4 < 0.1%
 
14400000 4 < 0.1%
 
28800000 4 < 0.1%
 
11300000 4 < 0.1%
 
67400000 3 < 0.1%
 
46600000 3 < 0.1%
 
Other values (4542) 4701 34.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 8867 65.2%
 
1000 1 < 0.1%
 
5500 1 < 0.1%
 
11000 1 < 0.1%
 
13500 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3.91607438e+11 1 < 0.1%
 
1.24290072e+11 1 < 0.1%
 
7.257735e+10 1 < 0.1%
 
7.024e+10 1 < 0.1%
 
5.5169364e+10 1 < 0.1%
 

total_sell_value_3m
Highly correlated

This variable is highly correlated with profit_6m and should be ignored for analysis

Correlation0.9617840254

total_sell_value_6m
Highly correlated

This variable is highly correlated with total_sell_value_3m and should be ignored for analysis

Correlation0.988218788

trading_date
Constant

This variable is constant and should be ignored for analysis

Constant value2019-09-30

trading_month
Constant

This variable is constant and should be ignored for analysis

Constant value9

Correlations

Missing values

Sample

First rows

Ageavg_cash_1mavg_cash_3mavg_cash_6mavg_loan_1mavg_loan_3mavg_loan_6mavg_portfolio_value_1mavg_portfolio_value_3mavg_portfolio_value_6mavg_profit_per_6mavg_stock_count_1mavg_stock_count_3mavg_stock_count_6mbuy_orderbuy_order_1mbuy_order_3mbuy_order_6mbuy_orders_1m_3m_perbuy_orders_1m_6m_percash_vs_1mcash_vs_3mcash_vs_6mCashBalanceGenderloan_vs_1mloan_vs_3mloan_vs_6mLoanBalancemain_accountnum_oderport_value_vs_1mport_value_vs_3mport_value_vs_6mportfolio_valueprofitprofit_1mprofit_3mprofit_6mprofit_perregionsell_ordersell_order_1msell_order_3msell_order_6msell_order_gainsell_order_losssell_orders_1m_3m_persell_orders_1m_6m_perstock_countstock_count_vs_1mstock_count_vs_3mstock_count_vs_6mtotal_buy_order_1m_3m_pertotal_buy_order_1m_6m_pertotal_buy_valuetotal_buy_value_1mtotal_buy_value_3mtotal_buy_value_6mtotal_sell_order_1m_3m_pertotal_sell_order_1m_6m_pertotal_sell_valuetotal_sell_value_1mtotal_sell_value_3mtotal_sell_value_6mtrading_datetrading_month
0561764517.702208024.381761109.13nannannan75117895.5077020380.7779136573.891.619.859.269.1301220.500.50-1346537.70-1790044.38-1343129.13417980.00Fnannannannan0001898ab3584ff6a99ec11ffcb1f09c0927824.50-974660.77-3090853.8976045720.0000-1516300-1516300nanHN0022000.000.00100.001.001.000.930.9309248000990920099092000.000.0000844200084420002019-09-309
1311303094.80403252.05209998.6135050012.79123084390.94153996251.2845792700.00170618307.69217354130.95-0.083.853.953.92035110.600.27-1150239.80-250397.05-57143.61152855.00F-23571153.79-111605531.94-142517392.2811478859.0000029e5f2da54460a1d7dd1a491d991f0-15452700.00-140278307.69-187014130.9530340000.000-63556460-82279590-83728490nanHN0469000.670.4440.000.000.000.560.130763200001363900005763625000.740.2802254330003032885008099585002019-09-309
23723146.0023143.9123141.06nannannan61965.0064250.7767576.19nan1.001.001.0000001.001.000.002.094.9423146.00Mnannannannan00057207ba05405a911387bbcb3861bc01335.00-950.77-4276.1963300.000000nanThanhHoa0000001.001.0010.000.000.001.001.0000001.001.0000002019-09-309
36454536987.1040602026.7522396767.01nannannan319849589.00338784400.31351875873.410.1419.6520.9421.390334570.090.05-22570.1013912390.2532117649.9954514417.00Mnannannannan000a64c8a9d5465eba885a561e1b0ca903833991.00-15100820.31-28192293.41323683580.000-1577501172376014026060nanDVSN034248000.070.0619-1.00-2.00-2.000.100.0607681000793845001263296000.060.05075380001229557001406657002019-09-309
4407768366.456756040.665297377.9977494639.00158683067.50204127222.7789628850.00211257232.31313340330.16-0.111.953.023.94014120.250.0811562148.5512574474.3414033137.0119330515.00Fnannannannan001d09340ebb4b95af55684d8635a8190-48591100.00-170219482.31-272302580.1641037750.000-21800000-22202500-46487500nanDVSN011016000.100.0620.00-1.00-2.000.010.00033207502481807507690807500.120.100916000007584161008825761002019-09-309
55518813004.4014705520.2014705520.20nannannan69927750.0071070666.6771070666.67-0.083.652.982.9802550.400.409349654.6013457138.8013457138.8028162659.00Mnannannannan0023387d6b544f53a9306495d5576cae0-11117750.00-12260666.67-12260666.6758810000.000-5370000-6270000-6270000nanHCM0233000.670.673-1.000.000.000.260.260336000001313650001313650000.740.7404536000061060000610600002019-09-309
6353391323.003388776.343386420.26222707013.35200418954.92182619916.76363438520.00340078321.54319609795.24-0.173.853.753.8703570.600.430.002546.664902.743391323.00M-7095702.3515192356.0832991394.24215611311.0000237505b9d5473186b894283286e3a70-1436220.0021923978.4642392504.76362002300.000-29790000-36869640-44580480nanBacNinh01610000.170.1040.000.000.000.380.3201024960002698200003236180000.810.6901620000002010845002338940002019-09-309
731275.00179100.422863666.171274397504.101285594458.351975358069.892007607000.001646555750.002552118421.57-0.001.902.241.880522510.230.100.00-178825.42-2863391.17275.00M-42361841.10-53558795.35-743322406.891232035663.000029fdde7ec841dbbf3c5166b50ed76d024925000.00385976250.00-519586421.572032532000.000-12580000-2008020-104984230nanHCM021633000.120.061-1.00-1.00-1.000.090.0205020000005324570500225254545000.070.0305559200007699907500203265890002019-09-309
8358050577.008871833.236652609.92nannannan244466550.00270283135.38274946692.300.247.007.487.75015110.200.09-7864875.00-8686131.23-6466907.92185702.00Mnannannannan002c1a2e3c054378b7261e680f19b5c40774450.00-25042135.38-29705692.30245241000.00001669450016721709nanHCM0037000.000.0070.000.00-1.000.070.050261000035910000527300000.000.000071080000715335102019-09-309
93588179.0088549.3489045.14nannannan2515660.002212118.461989566.67nan1.001.001.0000001.001.000.00-370.34-866.1488179.00Mnannannannan002c9f8d8f9842b9959f3f52bcc3b5be0233240.00536781.54759333.332748900.000000nanBacNinh0000001.001.0010.000.000.001.001.0000001.001.0000002019-09-309

Last rows

Ageavg_cash_1mavg_cash_3mavg_cash_6mavg_loan_1mavg_loan_3mavg_loan_6mavg_portfolio_value_1mavg_portfolio_value_3mavg_portfolio_value_6mavg_profit_per_6mavg_stock_count_1mavg_stock_count_3mavg_stock_count_6mbuy_orderbuy_order_1mbuy_order_3mbuy_order_6mbuy_orders_1m_3m_perbuy_orders_1m_6m_percash_vs_1mcash_vs_3mcash_vs_6mCashBalanceGenderloan_vs_1mloan_vs_3mloan_vs_6mLoanBalancemain_accountnum_oderport_value_vs_1mport_value_vs_3mport_value_vs_6mportfolio_valueprofitprofit_1mprofit_3mprofit_6mprofit_perregionsell_ordersell_order_1msell_order_3msell_order_6msell_order_gainsell_order_losssell_orders_1m_3m_persell_orders_1m_6m_perstock_countstock_count_vs_1mstock_count_vs_3mstock_count_vs_6mtotal_buy_order_1m_3m_pertotal_buy_order_1m_6m_pertotal_buy_valuetotal_buy_value_1mtotal_buy_value_3mtotal_buy_value_6mtotal_sell_order_1m_3m_pertotal_sell_order_1m_6m_pertotal_sell_valuetotal_sell_value_1mtotal_sell_value_3mtotal_sell_value_6mtrading_datetrading_month
13594321582745.001922349.221995344.72nannan68307961.4634596000.0036012923.0855203634.92-0.041.001.001.1000071.000.00-25550.00-365154.22-438149.721557195.00Mnannannannanffcfd3ca703a4b898dd7e84608c24ac20-996000.00-2412923.08-21603634.9233600000.00000-7750000nanBinhDinh0003001.000.0010.000.000.001.000.00000854420001.000.000001753000002019-09-309
1359551458492.00453035.09448177.23nannannan268360.00288443.08296463.49nan1.001.001.0000001.001.000.005456.9110314.77458492.00Mnannannannanffd2140f5c4e49da9179c45e7e38c3d40-360.00-20443.08-28463.49268000.000000nanHCM0000001.001.0010.000.000.001.001.0000001.001.0000002019-09-309
1359647nannannannannannan343477250.00325839827.69318587310.32nan1.001.001.0000001.001.00nannannannanMnannannannanffd57e6c45134224b6c81ca14fd47ec1019333450.0036970872.3144223389.68362810700.000000nanHCM0000001.001.0010.000.000.001.001.0000001.001.0000002019-09-309
135972619.00383.15382968.9386461940.50209378665.69303947833.91377500000.00516860000.00585950793.65-0.041.001.181.3800041.000.000.00-364.15-382949.9319.00M-66134.50-122982859.69-217552027.9186395806.00ffdf95af414245f285c0ec4e9196559502500000.00-136860000.00-205950793.65380000000.0000-39370000-35630000nanThaiBinh0034000.000.0010.000.000.001.000.000006278600000.000.00004164000004692000002019-09-309
135984141875.004726119.312443819.16nannannan229625.00217833.85212985.32nan1.001.001.0000001.001.000.00-4684244.31-2401944.1641875.00Fnannannannanffdfbcad4f2340f78012055b4c59f3ef012925.0024716.1529564.68242550.000000nanDVSN0000001.001.0010.000.000.001.001.0000001.001.0000002019-09-309
135995611985.0015096199.7421149290.36180696692.00151900093.20126343114.11334997500.00318949630.77291121111.11-0.062.002.092.0600260.000.000.00-15084214.74-21137305.3611985.00F-1282500.0027514098.8053071077.89179414192.00ffe8f9741d61422eac913ca1fce1c95f0-447500.0015600369.2343428888.89334550000.0000-42424000-36674000nanDVSN0035000.000.0020.000.000.000.000.000041890000010555250000.000.00003644510007209510002019-09-309
1360036152426.0091283.3553303.34157685875.79137145635.25140967703.35185371550.00154879649.23149589155.000.012.953.033.23010491000.200.101496075.001557217.651595197.661648501.00Mnannannannanffef4d87ab1f4afc96255d56b1eec7901-185371550.00-154879649.23-149589155.000.00-2283400-1465670782594019404240-0.03DVSN1124280010.290.151-2.00-2.00-2.000.150.070167302000114525230025086337000.270.1581095000378096000140176350025279595002019-09-309
136012925880513.0017845366.2615918281.18nannannan156722650.00137703953.85115902164.840.104.954.384.40028190.250.11-20700718.00-12665571.26-10738486.185179795.00Fnannannannanfff283aac89f4f82ab8b931dd9a9e41e013941350.0032960046.1554761835.16170664000.000-18400002402670038928300nanDVSN0134000.330.2550.001.001.000.600.3901583000002625940004109640000.120.090240000001922800002538100002019-09-309
13602291371899.001832260.382031132.77nannannan7853067.0013069290.7714585347.14-0.082.302.312.0100120.000.00-1371323.00-1831684.38-2030556.77576.00Mnannannannanfff942970c8d4976993aa8e949f2c2280-7803017.00-13019240.77-14535297.1450050.000-870000-2153100-2153100nanHCM0233000.670.671-1.00-1.00-1.000.000.00007000000142000000.600.6001333000022156600221566002019-09-309
1360335466813.003551778.282337714.13nannannan656058382.50708738775.38748528542.86nan1.001.001.0001111.001.000.00-3084965.28-1870901.13466813.00Fnannannannanfff95069a1554792bfe041e2f7b184bc081956317.5029275924.62-10513842.86738014700.000000nanDVSN0000001.001.0010.000.000.001.001.0003272040032720400327204001.001.0000002019-09-309